The LIBNAME option DBCONINIT= is used to pass a specific DBMS statement to be executed immediately after each DBMS connection is successfully established. If you use this option to submit the SET CURRENT SQLID= statement, the incorrect table can be referenced when that libref is used in subsequent code. The engine appropriately passes the statement to DB2. In subsequent code, however, rather than using that SQLID value, the engine uses either the value for the AUTHID=, SCHEMA=, or USER= option or the TSO ID under which the process is running. This occurs if none of those options were specified in the LIBNAME statement.

The only workaround is to use either the AUTHID= or the SCHEMA= option in the LIBNAME statement.

Operating System and Release Information